Catalog Search Results
22) SQL: kurz & gut
Author
Publisher
dpunkt
Pub. Date
2022.
Language
Deutsch
Description
Wenn Sie bei Ihrer täglichen Arbeit als Datenanalyst, Data Scientist oder Data Engineer SQL verwenden, ist dieses beliebte Taschenbuch das ideale Nachschlagewerk für Sie. Zahlreiche Beispiele verdeutlichen die Vielschichtigkeit der Sprache. Beschrieben werden außerdem wichtige Aspekte von SQL, die in Microsoft SQL Server, MySQL, Oracle Database, PostgreSQL und SQLite zum Einsatz kommen. In dieser aktualisierten Ausgabe zeigt die Autorin Alice Zhao,...
23) SQL injection strategies: practical techniques to secure old vulnerabilities against modern attacks
Author
Publisher
Packt Publishing
Pub. Date
2020.
Language
English
Description
Learn to exploit vulnerable database applications using SQL injection tools and techniques, while understanding how to effectively prevent attacks Key Features Understand SQL injection and its effects on websites and other systems Get hands-on with SQL injection using both manual and automated tools Explore practical tips for various attack and defense strategies relating to SQL injection Book Description SQL injection (SQLi) is probably the most...
Author
Publisher
PACKT PUBLISHING LIMITED
Pub. Date
2022
Language
English
Description
Learn the best way to write SQL in Java by taking control of SQL in your app via a type-safe, dynamic and versatile API that supports almost any type or feature compatible with a database and emphasizes SQL syntax correctness Key Features Write complex, type-safe, and dynamic SQL using the powerful jOOQ API Tackle complex persistence tasks, such as lazy fetching, R2DBC, transactions, and batching while sustaining high traffic in your modern Java applications...
25) Use Bard for SQL
Author
Series
Publisher
O'Reilly Media, Inc
Pub. Date
2023.
Language
English
Description
Bard AI is Google's answer to real time AI power. Unlike its well-known technological relative, ChatGPT, Bard is trained on an infiniset of data and can access the internet in real time. This makes it a powerful tool for anything other major LLMs can do, as well as contemporary research and working with cutting-edge technologies. Bard AI Shortcuts will tap into the experience of some of the greatest experts of our time to share quick lessons for overcoming...
Author
Publisher
Packt Publishing
Pub. Date
2020.
Language
English
Description
Database outages are costly and largely avoidable. That's why it's important to apply time-tested high availability techniques. This book will help you design and build an indestructible PostgreSQL 12 cluster that can remain online even in the direst circumstances. You will learn to monitor and automate your way to reassuring high availability.
Author
Publisher
Addison-Wesley
Pub. Date
[2017]
Language
English
Description
Presents practical solutions and insights for solving complex problems with SQL and designing databases that simplify data management in the future. Brings together advanced best practices and realistic example code for all of these versions of SQL: IBM DB2, Microsoft Access, Microsoft SQL Server, MySQL, Oracle Database, and PostgreSQL.
Author
Publisher
Packt Publishing, Limited
Pub. Date
2022
Language
English
Description
Master critical skills needed to deploy and use Databricks SQL and elevate your BI from the warehouse to the lakehouse with confidence Key Features Learn about business intelligence on the lakehouse with features and functions of Databricks SQL Make the most of Databricks SQL by getting to grips with the enablers of its data warehousing capabilities A unique approach to teaching concepts and techniques with follow-along scenarios on real datasets...
Author
Series
Publisher
Addison-Wesley
Pub. Date
[2018]
Language
English
Description
This book on generic SQL can be used by new users to learn the foundations of SQL or act as a reference for more experienced users. This new edition brings the content up-to-date with the latest versions of the major proprietary database systems, including Access, Oracle and MySQL.
Author
Publisher
Packt Publishing Ltd
Pub. Date
2022.
Language
English
Description
SQL Server is a relational database management system developed by Microsoft. As a database server, it is a software product with the primary function of storing and retrieving data as requested by other software applications. This book starts by describing the inner workings of the query optimizer, and will enable you to use this knowledge to write better queries and provide the query engine with all the information it needs to produce efficient...
Author
Publisher
SAS Institute
Pub. Date
2019.
Language
English
Description
PROC SQL: Beyond the Basics Using SAS®, Third Edition, is a step-by-step, example-driven guide that helps readers master the language of PROC SQL. Packed with analysis and examples illustrating an assortment of PROC SQL options, statements, and clauses, this book not only covers all the basics, but it also offers extensive guidance on complex topics such as set operators and correlated subqueries. Programmers at all levels will appreciate Kirk Lafler's...
Author
Publisher
Manning Publications
Pub. Date
2022.
Language
English
Description
If you work with SQL Server, dbatools is a lifesaver. This book will show you how to use this free and open source PowerShell module to automate just about every SQL server task you can imagine-all in just one month! Written by a group of expert authors including dbatools creator Chrissy LeMaire, Learn dbatools in a Month of Lunches teaches you techniques that will make you more effective-and efficient-than you ever thought possible. In twenty-eight...
Author
Publisher
Wiley
Pub. Date
2019
Language
English
Description
Business Intelligence (BI) has emerged as a field which seeks to support managers in decision-making. It encompasses the techniques, methods and tools for conducting analytically-based IT solutions, which are referred to as OLAP (OnLine Analytical Processing). Within this field, SQL has a role as a leader and is continuously evolving to cover both transactional and analytical data management. This book discusses the functions provided by Microsoft...
Author
Publisher
Packt Publishing Ltd
Pub. Date
2023.
Language
English
Description
Starting with an introduction to the newly released features of PostgreSQL 15, this updated fifth edition will help you get to grips with PostgreSQL administration and how to build dynamic database solutions for enterprise apps, including designing both physical and technical aspects of the system. You'll explore advanced PostgreSQL features, such as logical replication, database clusters, advanced indexing, and user management to manage and maintain...
Author
Publisher
O'Reilly Media
Pub. Date
[2022]
Language
English
Description
For MySQL, the price of popularity comes with a flood of questions from users on how to solve specific data-related issues. That's where this cookbook comes in. When you need quick solutions or techniques, this handy resource provides scores of short, focused pieces of code, hundreds of worked-out examples, and clear, concise explanations for programmers who don't have the time (or expertise) to resolve MySQL problems from scratch. In this updated...
37) Practical fraud prevention: fraud and AML analytics for Fintech and eCommerce, using SQL and Python
Author
Publisher
O'Reilly Media, Inc
Pub. Date
2022.
Language
English
Description
Over the past two decades, the booming ecommerce and fintech industries have become a breeding ground for fraud. Organizations that conduct business online are constantly engaged in a cat-and-mouse game with these invaders. In this practical book, Gilit Saporta and Shoshana Maraney draw on their fraud-fighting experience to provide best practices, methodologies, and tools to help you detect and prevent fraud and other malicious activities. Data scientists,...
Author
Publisher
Packt Publishing
Pub. Date
2022.
Language
English
Description
Every day, businesses operate around the clock, and a huge amount of data is generated at a rapid pace. This book helps you analyze this data and identify key patterns and behaviors that can help you and your business understand your customers at a deep, fundamental level. SQL for Data Analytics, Third Edition is a great way to get started with data analysis, showing how to effectively sort and process information from raw data, even without any prior...
Author
Publisher
O'Reilly Media
Pub. Date
[2019]
Language
English
Description
Fast access to data has become a critical game changer. Today, a new breed of company understands that the faster they can build, access, and share well-defined datasets, the more competitive they'll be in our data-driven world. In this practical report, Scott Haines from Twilio introduces you to operational analytics, a new approach for making sense of all the data flooding into business systems. Data architects and data scientists will see how Apache...
Author
Series
Publisher
Pearson Educationm Inc
Pub. Date
[2022]
Language
English
Description
Featuring step-by-step instructions that walk you through the most common SQL tasks, this authoritative resource helps you use SQL to build effective data bases, efficiently review data and manage everything from performance to security.
Didn't find it?
Can't find what you are looking for? Try our Materials Request Service. Submit Request